Elements and Performance Criteria
- Create a simple database
- Plan a simple one-to-one relational database, using a database application, basic design principles, software functions and simple formulae
- Develop a table with fields and attributes according to database usage, as well as data considerations and user requirements
- Create a primary key for each table
- Create a relationship between the two tables by assigning a foreign key
- Modify table layout and field attributes as required
- Check and amend data entered, in accordance with organisational and task requirements
- Create reports and queries
- Identify information output, database tables to be used and report layout, in accordance with task requirements
- Identify data groupings, search and sort criteria, in accordance with task requirements
- Run reports and queries to check that results and formulae provide the required data
- Modify reports to include or exclude additional requirements, where necessary
- Use database
- Ensure data input meets designated timelines and organisational requirements for speed and accuracy
- Use help functions to overcome simple issues with database design and production
- Preview, adjust and produce database reports or forms in accordance with organisational and task requirements
- Name and store databases, in accordance with organisational requirements, and exit application without data loss or damage
- Prepare and distribute reports to appropriate personnel in a suitable format